CREATE TABLE [dbo].[TCFLUJ_PROY_SEMA]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[NU_ANIO] [dbo].[TD_IN_004_ANOS] NOT NULL,
[NU_SECU] [dbo].[TD_IN_001] NOT NULL CONSTRAINT [DF__TCFLUJ_PR__NU_SE__690797E6] DEFAULT ((0)),
[FE_PROY] [dbo].[TD_DT_001] NOT NULL,
[CO_MONE] [dbo].[TD_VC_003] NOT NULL,
[ST_PROC] [dbo].[TD_VC_001_SINO] NOT NULL CONSTRAINT [DF__TCFLUJ_PR__ST_PR__69FBBC1F] DEFAULT ('N'),
[FA_TIPO_CAMB] [dbo].[TD_NU_016_004] NULL CONSTRAINT [DF__TCFLUJ_PR__FA_TI__6BE40491] DEFAULT ((0)),
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TCFLUJ_PR__CO_US__6CD828CA] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TCFLUJ_PR__FE_US__6DCC4D03] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TCFLUJ_PR__CO_US__6EC0713C] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TCFLUJ_PR__FE_US__6FB49575] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCFLUJ_PROY_SEMA] WITH NOCHECK ADD CONSTRAINT [CK__TCFLUJ_PR__NU_AN__681373AD] CHECK NOT FOR REPLICATION (([NU_ANIO]>(1980)))
GO
ALTER TABLE [dbo].[TCFLUJ_PROY_SEMA] WITH NOCHECK ADD CONSTRAINT [CK__TCFLUJ_PR__ST_PR__6AEFE058] CHECK NOT FOR REPLICATION (([ST_PROC]='N' OR [ST_PROC]='S'))
GO
ALTER TABLE [dbo].[TCFLUJ_PROY_SEMA] ADD CONSTRAINT [PK__TCFLUJ_P__17D9AB471AB4CD6A] PRIMARY KEY CLUSTERED  ([CO_EMPR]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCFLUJ_PROY_SEMA] ADD CONSTRAINT [FK__TCFLUJ_PR__CO_EM__094028A5] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMPARA_TESO] ([CO_EMPR])
GO
